Overview

Dataset Statistics

Number of Variables 8
Number of Rows 8898
Missing Cells 3246
Missing Cells (%) 4.6%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 981.6 KB
Average Row Size in Memory 113.0 B
Variable Types
  • DateTime: 2
  • Numerical: 5
  • Categorical: 1

Dataset Insights

REG_USER has 1623 (18.24%) missing values Missing
DL01_SALES is skewed Skewed
DL02_SALES is skewed Skewed
DL03_SALES is skewed Skewed
DL04_SALES is skewed Skewed

Variables


Date

datetime

Distinct Count 8918.1833
Approximate Unique (%) 100.2%
Missing 0
Missing (%) 0.0%
Memory Size 69.6 KB
Minimum 2020-01-01 00:00:00
Maximum 2021-01-06 12:00:00

DL01_SALES

numerical

Approximate Distinct Count 611
Approximate Unique (%) 6.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 139.0 KB
Mean 1929.0551
Minimum 0
Maximum 9848
Zeros 21
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%
  • DL01_SALES is skewed right (γ1 = 2.0493)

Quantile Statistics

Minimum 0
5-th Percentile 1224
Q1 1478.5
Median 1840
Q3 2280
95-th Percentile 2912
Maximum 9848
Range 9848
IQR 801.5

Descriptive Statistics

Mean 1929.0551
Standard Deviation 600.8588
Variance 361031.2758
Sum 1.7165e+07
Skewness 2.0493
Kurtosis 16.393
Coefficient of Variation 0.3115
  • DL01_SALES is not normally distributed (p-value 7.585184150899897e-08)
  • DL01_SALES has 128 outliers

DL02_SALES

numerical

Approximate Distinct Count 540
Approximate Unique (%) 6.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 139.0 KB
Mean 1649.3529
Minimum 0
Maximum 9752
Zeros 21
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%
  • DL02_SALES is skewed right (γ1 = 2.945)

Quantile Statistics

Minimum 0
5-th Percentile 1040
Q1 1288
Median 1592
Q3 1928
95-th Percentile 2464
Maximum 9752
Range 9752
IQR 640

Descriptive Statistics

Mean 1649.3529
Standard Deviation 509.8548
Variance 259951.9065
Sum 1.4676e+07
Skewness 2.945
Kurtosis 33.2398
Coefficient of Variation 0.3091
  • DL02_SALES is not normally distributed (p-value 2.220327111442508e-08)
  • DL02_SALES has 153 outliers

DL03_SALES

numerical

Approximate Distinct Count 579
Approximate Unique (%) 6.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 139.0 KB
Mean 1759.1095
Minimum 0
Maximum 9968
Zeros 21
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%
  • DL03_SALES is skewed right (γ1 = 1.6771)

Quantile Statistics

Minimum 0
5-th Percentile 976
Q1 1248
Median 1752
Q3 2152
95-th Percentile 2680
Maximum 9968
Range 9968
IQR 904

Descriptive Statistics

Mean 1759.1095
Standard Deviation 603.0656
Variance 363688.0946
Sum 1.5653e+07
Skewness 1.6771
Kurtosis 14.2113
Coefficient of Variation 0.3428
  • DL03_SALES is not normally distributed (p-value 6.130163513243334e-07)
  • DL03_SALES has 57 outliers

DL04_SALES

numerical

Approximate Distinct Count 600
Approximate Unique (%) 6.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 139.0 KB
Mean 1025.9344
Minimum 0
Maximum 9832
Zeros 21
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%
  • DL04_SALES is skewed right (γ1 = 6.3016)

Quantile Statistics

Minimum 0
5-th Percentile 604
Q1 740
Median 960
Q3 1204
95-th Percentile 1680
Maximum 9832
Range 9832
IQR 464

Descriptive Statistics

Mean 1025.9344
Standard Deviation 436.8243
Variance 190815.4349
Sum 9.1288e+06
Skewness 6.3016
Kurtosis 94.3159
Coefficient of Variation 0.4258
  • DL04_SALES is not normally distributed (p-value 3.0465568792648024e-13)
  • DL04_SALES has 198 outliers

TOTAL_SALES

numerical

Approximate Distinct Count 3651
Approximate Unique (%) 41.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 139.0 KB
Mean 7261.0472
Minimum 0
Maximum 34680
Zeros 21
Zeros (%) 0.2%
Negatives 0
Negatives (%) 0.0%
  • TOTAL_SALES is skewed right (γ1 = 1.813)

Quantile Statistics

Minimum 0
5-th Percentile 4280
Q1 5338
Median 7025
Q3 8748
95-th Percentile 11080.3
Maximum 34680
Range 34680
IQR 3410

Descriptive Statistics

Mean 7261.0472
Standard Deviation 2429.2334
Variance 5.9012e+06
Sum 6.4609e+07
Skewness 1.813
Kurtosis 12.0718
Coefficient of Variation 0.3346
  • TOTAL_SALES is not normally distributed (p-value 3.60063484869817e-06)
  • TOTAL_SALES has 100 outliers

REG_DT

datetime

Distinct Count 1131.7156
Approximate Unique (%) 15.6%
Missing 1623
Missing (%) 18.2%
Memory Size 69.6 KB
Minimum 2020-04-23 14:36:46
Maximum 2021-01-06 12:33:52

REG_USER

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 1623
Missing (%) 18.2%
Memory Size 513.7 KB
  • The largest value (admin) is over 2.04 times larger than the second largest value (DataUploader)

Length

Mean 7.3045
Standard Deviation 3.2897
Median 5
Minimum 5
Maximum 12

Sample

1st row admin
2nd row admin
3rd row admin
4th row admin
5th row admin

Letter

Count 53140
Lowercase Letter 48350
Space Separator 0
Uppercase Letter 4790
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (admin, DataUploader) take over 50.0%
  • The largest value (admin) is over 2.04 times larger than the second largest value (datauploader)

Interactions

Correlations

Missing Values